package quary;

public class VinylDataVar {

	public static final String DB = "jdbc:mysql://localhost/vinylklubb";
	public static final String USERNAME = "root";
	public static final String PASSWORD = "kalium123";
	
	public static final String CLUBHOUSE = "klubbhus C";
	public static final String CLUBHOUSE_ID = "C.klubbhus_id";
	public static final String CLUBHOUSE_NAME = "C.navn";
	public static final String CLUBHOUSE_ADDRESS = "C.adresse";
	public static final String CLUBHOUSE_ZIP = "C.postnummer";
	public static final String CLUBHOUSE_LOCATION = "C.sted";
	public static final String CLUBHOUSE_PHONE = "C.telefon";
	
	public static final String MEMBER = "medlem M";
	public static final String MEMBER_ID = "M.medlem_id";
	public static final String MEMBER_PERSON_ID = "M.person_id";
	public static final String MEMBER_REG_DATE = "M.registrerings_dato";
	public static final String MEMBER_POSITION = "M.stilling";
	
	public static final String PERSON = "person P";
	public static final String PERSON_ID = "P.person_id";
	public static final String PERSON_FIRST_NAME = "P.fornavn";
	public static final String PERSON_MIDDLE_NAME = "P.mellomnavn";
	public static final String PERSON_LAST_NAME = "P.etternavn";
	public static final String PERSON_ADDRESS = "P.adresse";
	public static final String PERSON_ZIP = "P.postnummer";
	public static final String PERSON_LOCATION = "P.sted";
	public static final String PERSON_PHONE = "P.telefon";
	public static final String PERSON_EMAIL = "P.epost";
	
	public static final String STORAGE = "plassering S";
	public static final String STORAGE_ID = "S.plass_id";
	public static final String STORAGE_IN_CLUBHOUSE = "S.i_klubbhus";
	public static final String STORAGE_AT_MEMBER = "S.hos_medlem";
	public static final String STORAGE_DESCRIPTION = "S.beskrivelse";
	
	public static final String ACCESS = "tilgang T";
	public static final String ACCESS_MEMBER_ID = "T.medlem_id";
	public static final String ACCESS_STORAGE_ID = "T.plass_id";
	
	public static final String LOANS = "utlaan U";
	public static final String LOANS_VINYL_ID = "U.vinyl_id";
	public static final String LOANS_MEMBER_ID = "U.medlem_id";
	public static final String LOANS_LOAN_DATE = "U.laans_dato";
	public static final String LOANS_DELIVERY_DATE = "U.leverings_dato";

	public static final String VINYL = "vinyl V";
	public static final String VINYL_ID = "V.vinyl_id";
	public static final String VINYL_ARTIST = "V.artist";
	public static final String VINYL_ALBUM = "V.album";
	public static final String VINYL_MUSIC_STYLE = "V.musikk_stil";
	public static final String VINYL_FORMAT = "V.format";
	public static final String VINYL_LABEL = "V.plateselskap";
	public static final String VINYL_OWNER = "V.eier";
	public static final String VINYL_DELIVERY_DATE = "V.levers_til_eier";
	public static final String VINYL_STORAGE = "V.plassering";
}
